package com.bonc.modules.rpt.entity;

import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.format.NumberFormat;
import com.baomidou.mybatisplus.annotation.TableName;
import com.bonc.common.utils.BigDecimalSerialize;
import com.fasterxml.jackson.databind.annotation.JsonSerialize;
import lombok.Data;

import java.math.BigDecimal;

/**
 * @author jinlong
 * @date 2021/8/18
 */
@Data
@TableName("TB_RPT_SERV_CORE_COMPLAIN_MON")
public class PeakShavingEntity {

    @ExcelProperty("处理日期")
    private Integer dealDate;
    @ExcelIgnore
    private String dimId;
    @ExcelIgnore
    private String dimName;
    @ExcelIgnore
    private String regionCode;
    @ExcelProperty("地市")
    private String regionDesc;
    @ExcelIgnore
    private String areaCode;
    @ExcelProperty("区县")
    private String areaDesc;
    @ExcelIgnore
    private String griddingCode;
    @ExcelProperty("网格")
    private String griddingDesc;
    @ExcelProperty("互联网电视-栏目点播、电视看点、电视[直播]无法观看")
    private BigDecimal q1Value;
    @ExcelProperty("资费套餐-对产生超套费用不认可")
    private BigDecimal q2Value;
    @ExcelProperty("资费套餐-营销宣传有误/不明确（含服务触点（2级节点)-业务解释差错（6级节点））")
    private BigDecimal q3Value;
    @ExcelProperty("资费套餐-对套餐内资源扣减不认可")
    private BigDecimal q4Value;
    @ExcelProperty("资费套餐-客户误办理")
    private BigDecimal q5Value;
    @ExcelProperty("本省业务营销-本省问题(含社会渠道：业务办理及解释差错)")
    private BigDecimal q6Value;
    @ExcelProperty("手机上网（4G）-网速慢或网页无法打开")
    private BigDecimal q7Value;
    @ExcelProperty("2、3G节点下（包含语音、上网）")
    private BigDecimal q8Value;
    @ExcelProperty("新增：资费套餐-提醒延迟/未收到提醒导致扣费（含：流量/语音使用提醒-客户没有收到提醒）")
    private BigDecimal q9Value;
    @ExcelProperty("家庭宽带-网络连接掉线")
    private BigDecimal q10Value;
    @ExcelProperty("家庭宽带-所有网页速度慢")
    private BigDecimal q11Value;
    @ExcelProperty("家庭宽带-网络无法连接")
    private BigDecimal q12Value;
    @ExcelProperty("家庭宽带-LOS红灯，无法上网")
    private BigDecimal q13Value;
    @ExcelProperty("家庭宽带-路由器死机/损坏/设置错误")
    private BigDecimal q14Value;
    @ExcelProperty("家庭宽带-上行网速慢")
    private BigDecimal q15Value;
    @ExcelProperty("本月合计")
    private BigDecimal totalValue;
    @ExcelProperty("非家宽问题本月合计")
    private BigDecimal notKdTotalValue;
    @ExcelProperty("家宽问题本月合计")
    private BigDecimal kdTotalValue;
    @ExcelProperty("上年合计")
    private BigDecimal lastYearValue;
    @ExcelProperty("上年月均合计")
    private BigDecimal lastYearAvgMonValue;
    @ExcelProperty("当年目标")
    private BigDecimal upperBoundValue;
    @ExcelProperty("当年月均目标")
    private BigDecimal upperBoundAvgMonValue;
    @ExcelProperty("同比降幅（当月比上年月均）")
    @NumberFormat("#.##%")
    @JsonSerialize(using = BigDecimalSerialize.class)
    private BigDecimal thisMonDecreasePercnt;
    @ExcelProperty("当月是否达到目标")
    private String isnReachGoalMon;
    @ExcelProperty("非宽节点当年月均")
    private BigDecimal notKdAvgValueThisYear;
    @ExcelProperty("家宽节点当年月均")
    private BigDecimal kdAvgValueThisYear;
    @ExcelProperty("当年月均总投诉量")
    private BigDecimal avgTotValueThisYear;
    @ExcelProperty("当年月均同比")
    @NumberFormat("#.##%")
    @JsonSerialize(using = BigDecimalSerialize.class)
    private BigDecimal avgTotValueDecreasePercent;
    @ExcelProperty("当年是否达到目标")
    private String isnReachGoalYear;
}
